Creating a Drop Down List in Excel 2007 - Spreadsheets - About.com A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data entry, but it can also prevent people from ...